Problem Note 50911: Facts might not be deleted when loading new data using the SAS® Financial Management load base data jobs in SAS® Data Integration Studio
 |  |  |  |
In SAS Financial Management, you can load transactions using the Load
Data Wizard in SAS Financial Management Studio, the
fm_1100_load_base_data job or the fm_1100_load_base_data_unlock_periods
in SAS Data Integration Studio, or user-written code that calls either
the %ETLLDFCT macro or the %ETLLDFTU macro.
When you use the jobs in SAS Data Integration Studio or user-written code, you must specify the dimension member selection list to use in selecting which transactions are loaded. Here is an example:
It is important to note that the observations in this table must be in dimension type order as shown above.
If the dimension member selection table contains observations that are not sorted by dimension type (as shown below) and you select Replace all, the existing fact records for these crossing might not be deleted. This could result in the fact values being inadvertently doubled.
To correct this problem, unzip this ZIP file and extract the contents to the relevant location:
UNIX: SAS_93/sasmacro/finance
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Financial Management | Microsoft® Windows® for x64 | 5.3_M1 | 9.3 TS1M2 | 9.4 TS1M0 | |
| Microsoft Windows 8 Enterprise 32-bit | 5.3_M1 | 9.3 TS1M2 | 9.4 TS1M0 | |||
| Microsoft Windows 8 Enterprise x64 | 5.3_M1 | 9.3 TS1M2 | 9.4 TS1M0 | |||
| Microsoft Windows 8 Pro 32-bit | 5.3_M1 | 9.3 TS1M2 | 9.4 TS1M0 | |||
| Microsoft Windows 8 Pro x64 | 5.3_M1 | 9.3 TS1M2 | 9.4 TS1M0 | |||
| Microsoft Windows Server 2003 Datacenter Edition | 5.3_M1 | 9.3 TS1M2 | ||||
| Microsoft Windows Server 2003 Enterprise Edition | 5.3_M1 | 9.3 TS1M2 | ||||
| Microsoft Windows Server 2003 Standard Edition | 5.3_M1 | 9.3 TS1M2 | ||||
| Microsoft Windows Server 2003 for x64 | 5.3_M1 | 9.3 TS1M2 | ||||
| Microsoft Windows Server 2008 | 5.3_M1 | 9.3 TS1M2 | ||||
| Microsoft Windows Server 2008 R2 | 5.3_M1 | 9.3 TS1M2 | 9.4 TS1M0 | |||
| Microsoft Windows Server 2008 for x64 | 5.3_M1 | 9.3 TS1M2 | 9.4 TS1M0 | |||
| Microsoft Windows Server 2012 Datacenter | 5.3_M1 | 9.3 TS1M2 | 9.4 TS1M0 | |||
| Microsoft Windows Server 2012 Std | 5.3_M1 | 9.3 TS1M2 | 9.4 TS1M0 | |||
| Microsoft Windows XP Professional | 5.3_M1 | 9.3 TS1M2 | ||||
| Windows 7 Enterprise 32 bit | 5.3_M1 | 9.3 TS1M2 | ||||
| Windows 7 Enterprise x64 | 5.3_M1 | 9.3 TS1M2 | 9.4 TS1M0 | |||
| Windows 7 Home Premium 32 bit | 5.3_M1 | 9.3 TS1M2 | ||||
| Windows 7 Home Premium x64 | 5.3_M1 | 9.3 TS1M2 | ||||
| Windows 7 Professional 32 bit | 5.3_M1 | 9.3 TS1M2 | ||||
| Windows 7 Professional x64 | 5.3_M1 | 9.3 TS1M2 | 9.4 TS1M0 | |||
| Windows 7 Ultimate 32 bit | 5.3_M1 | 9.3 TS1M2 | ||||
| Windows 7 Ultimate x64 | 5.3_M1 | 9.3 TS1M2 | ||||
| Windows Vista | 5.3_M1 | 9.3 TS1M2 | ||||
| Windows Vista for x64 | 5.3_M1 | 9.3 TS1M2 | ||||
| 64-bit Enabled AIX | 5.3_M1 | 9.3 TS1M2 | 9.4 TS1M0 | |||
| 64-bit Enabled Solaris | 5.3_M1 | 9.3 TS1M2 | 9.4 TS1M0 | |||
| HP-UX IPF | 5.3_M1 | 9.3 TS1M2 | 9.4 TS1M0 | |||
| Linux for x64 | 5.3_M1 | 9.3 TS1M2 | 9.4 TS1M0 | |||
| Solaris for x64 | 5.3_M1 | 9.3 TS1M2 | 9.4 TS1M0 | |||